Tabela NFZContractServiceData

Definicja tabeli NFZContractServiceData

Name

NFZContractServiceData

Code

NFZContractServiceData

Comment

 


Lista kolumn tabeli NFZContractServiceData

Name

Code

PerfContractServiceID

PerfContractServiceID

NFZSpecificAccountingID

NFZSpecificAccountingID

NFZTherapyTypeID

NFZTherapyTypeID

ResourceID

ResourceID

CivilInsuranceID

CivilInsuranceID

PatientAgreementTypeID

PatientAgreementTypeID

MedicalProductDetailsID

MedicalProductDetailsID

PatientSurcharge

PatientSurcharge

ContractorCost

ContractorCost

isEmergency

isEmergency

LocationCode

LocationCode

ToothArea

ToothArea

PerfUnitsCount

PerfUnitsCount

DrugUnitsCount

DrugUnitsCount

HaemoglibinConcentration

HaemoglibinConcentration

PerfUnit

PerfUnit

PatientAgreementNo

PatientAgreementNo

TreatmentDayNo

TreatmentDayNo

IsGivenToPatient

IsGivenToPatient

GivenDaysAmount

GivenDaysAmount

GrouperVersion

GrouperVersion

CivilInsuranceDocNo

CivilInsuranceDocNo

DaysAdditional

DaysAdditional

GPBarthel

GPBarthel

GPCare

GPCare

GPCareStopDT

GPCareStopDT

InvoiceNo

InvoiceNo

IsPatientAgreementNoUsedDRG

IsPatientAgreementNoUsedDRG

DRGHospDays

DRGHospDays

DateRestrictionYear

DateRestrictionYear

DateRestrictionMonthNo

DateRestrictionMonthNo

DrugAmount

DrugAmount

BodyWeight

BodyWeight

BodySurface

BodySurface

ImportedDrugUnitPrice

ImportedDrugUnitPrice

TreatmentSchemaID

TreatmentSchemaID

DoseCalcMethodID

DoseCalcMethodID

SplitContractCoding

SplitContractCoding

SPOGlasgowEyesOpen

SPOGlasgowEyesOpen

SPOGlasgowVerbalContact

SPOGlasgowVerbalContact

SPOGlasgowMovementResponse

SPOGlasgowMovementResponse

SPOGlasgowSum

SPOGlasgowSum

SPOBarthel

SPOBarthel

EAN

EAN

DrugPackagePrice

DrugPackagePrice

DrugPackageUnitsCount

DrugPackageUnitsCount

OutpatientMode

OutpatientMode

DrugTherapyStartDT

DrugTherapyStartDT

DrugTherapyStopDT

DrugTherapyStopDT

PregnancyWeek

PregnancyWeek


Kolumna PerfContractServiceID tabeli NFZContractServiceData

Definicja kolumny PerfContractServiceID tabeli NFZContractServiceData

Name

PerfContractServiceID

Code

PerfContractServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna NFZSpecificAccountingID tabeli NFZContractServiceData

Definicja kolumny NFZSpecificAccountingID tabeli NFZContractServiceData

Name

NFZSpecificAccountingID

Code

NFZSpecificAccountingID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NFZTherapyTypeID tabeli NFZContractServiceData

Definicja kolumny NFZTherapyTypeID tabeli NFZContractServiceData

Name

NFZTherapyTypeID

Code

NFZTherapyTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli NFZContractServiceData

Definicja kolumny ResourceID tabeli NFZContractServiceData

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CivilInsuranceID tabeli NFZContractServiceData

Definicja kolumny CivilInsuranceID tabeli NFZContractServiceData

Name

CivilInsuranceID

Code

CivilInsuranceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientAgreementTypeID tabeli NFZContractServiceData

Definicja kolumny PatientAgreementTypeID tabeli NFZContractServiceData

Name

PatientAgreementTypeID

Code

PatientAgreementTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MedicalProductDetailsID tabeli NFZContractServiceData

Definicja kolumny MedicalProductDetailsID tabeli NFZContractServiceData

Name

MedicalProductDetailsID

Code

MedicalProductDetailsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientSurcharge tabeli NFZContractServiceData

Definicja kolumny PatientSurcharge tabeli NFZContractServiceData

Name

PatientSurcharge

Code

PatientSurcharge

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna ContractorCost tabeli NFZContractServiceData

Definicja kolumny ContractorCost tabeli NFZContractServiceData

Name

ContractorCost

Code

ContractorCost

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna isEmergency tabeli NFZContractServiceData

Definicja kolumny isEmergency tabeli NFZContractServiceData

Name

isEmergency

Code

isEmergency

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LocationCode tabeli NFZContractServiceData

Definicja kolumny LocationCode tabeli NFZContractServiceData

Name

LocationCode

Code

LocationCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna ToothArea tabeli NFZContractServiceData

Definicja kolumny ToothArea tabeli NFZContractServiceData

Name

ToothArea

Code

ToothArea

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna PerfUnitsCount tabeli NFZContractServiceData

Definicja kolumny PerfUnitsCount tabeli NFZContractServiceData

Name

PerfUnitsCount

Code

PerfUnitsCount

Data Type

NUMBER(19,10)

Mandatory

No

Comment

 


Kolumna DrugUnitsCount tabeli NFZContractServiceData

Definicja kolumny DrugUnitsCount tabeli NFZContractServiceData

Name

DrugUnitsCount

Code

DrugUnitsCount

Data Type

NUMBER(12,3)

Mandatory

No

Comment

 


Kolumna HaemoglibinConcentration tabeli NFZContractServiceData

Definicja kolumny HaemoglibinConcentration tabeli NFZContractServiceData

Name

HaemoglibinConcentration

Code

HaemoglibinConcentration

Data Type

NUMBER(6,2)

Mandatory

No

Comment

 


Kolumna PerfUnit tabeli NFZContractServiceData

Definicja kolumny PerfUnit tabeli NFZContractServiceData

Name

PerfUnit

Code

PerfUnit

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PatientAgreementNo tabeli NFZContractServiceData

Definicja kolumny PatientAgreementNo tabeli NFZContractServiceData

Name

PatientAgreementNo

Code

PatientAgreementNo

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna TreatmentDayNo tabeli NFZContractServiceData

Definicja kolumny TreatmentDayNo tabeli NFZContractServiceData

Name

TreatmentDayNo

Code

TreatmentDayNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna IsGivenToPatient tabeli NFZContractServiceData

Definicja kolumny IsGivenToPatient tabeli NFZContractServiceData

Name

IsGivenToPatient

Code

IsGivenToPatient

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna GivenDaysAmount tabeli NFZContractServiceData

Definicja kolumny GivenDaysAmount tabeli NFZContractServiceData

Name

GivenDaysAmount

Code

GivenDaysAmount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GrouperVersion tabeli NFZContractServiceData

Definicja kolumny GrouperVersion tabeli NFZContractServiceData

Name

GrouperVersion

Code

GrouperVersion

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna CivilInsuranceDocNo tabeli NFZContractServiceData

Definicja kolumny CivilInsuranceDocNo tabeli NFZContractServiceData

Name

CivilInsuranceDocNo

Code

CivilInsuranceDocNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna DaysAdditional tabeli NFZContractServiceData

Definicja kolumny DaysAdditional tabeli NFZContractServiceData

Name

DaysAdditional

Code

DaysAdditional

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna GPBarthel tabeli NFZContractServiceData

Definicja kolumny GPBarthel tabeli NFZContractServiceData

Name

GPBarthel

Code

GPBarthel

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GPCare tabeli NFZContractServiceData

Definicja kolumny GPCare tabeli NFZContractServiceData

Name

GPCare

Code

GPCare

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna GPCareStopDT tabeli NFZContractServiceData

Definicja kolumny GPCareStopDT tabeli NFZContractServiceData

Name

GPCareStopDT

Code

GPCareStopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna InvoiceNo tabeli NFZContractServiceData

Definicja kolumny InvoiceNo tabeli NFZContractServiceData

Name

InvoiceNo

Code

InvoiceNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna IsPatientAgreementNoUsedDRG tabeli NFZContractServiceData

Definicja kolumny IsPatientAgreementNoUsedDRG tabeli NFZContractServiceData

Name

IsPatientAgreementNoUsedDRG

Code

IsPatientAgreementNoUsedDRG

Data Type

NUMBER(5)

Mandatory

No

Comment

Pole ma sugerowac uzycie badz nie wartosci z PatientAgreementNo podczas
procesu grupowania.


Kolumna DRGHospDays tabeli NFZContractServiceData

Definicja kolumny DRGHospDays tabeli NFZContractServiceData

Name

DRGHospDays

Code

DRGHospDays

Data Type

NUMBER(5)

Mandatory

No

Comment

Liczba osobodni dla JGP w kontekscie epizodu..


Kolumna DateRestrictionYear tabeli NFZContractServiceData

Definicja kolumny DateRestrictionYear tabeli NFZContractServiceData

Name

DateRestrictionYear

Code

DateRestrictionYear

Data Type

NUMBER(5)

Mandatory

No

Comment

Dane dotyczace schematu wyznaczania
miesiaca sprawozdawczego oraz schematu krotnosci realizacji.


Kolumna DateRestrictionMonthNo tabeli NFZContractServiceData

Definicja kolumny DateRestrictionMonthNo tabeli NFZContractServiceData

Name

DateRestrictionMonthNo

Code

DateRestrictionMonthNo

Data Type

NUMBER(5)

Mandatory

No

Comment

Dane dotyczace schematu wyznaczania
miesiaca sprawozdawczego oraz schematu krotnosci realizacji.


Kolumna DrugAmount tabeli NFZContractServiceData

Definicja kolumny DrugAmount tabeli NFZContractServiceData

Name

DrugAmount

Code

DrugAmount

Data Type

NUMBER(22,10)

Mandatory

No

Comment

Zakodowana ilosc substancji czynnej dla
chemioterapii niestandardowej.


Kolumna BodyWeight tabeli NFZContractServiceData

Definicja kolumny BodyWeight tabeli NFZContractServiceData

Name

BodyWeight

Code

BodyWeight

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Masa ciala


Kolumna BodySurface tabeli NFZContractServiceData

Definicja kolumny BodySurface tabeli NFZContractServiceData

Name

BodySurface

Code

BodySurface

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Powierzchnia ciala


Kolumna ImportedDrugUnitPrice tabeli NFZContractServiceData

Definicja kolumny ImportedDrugUnitPrice tabeli NFZContractServiceData

Name

ImportedDrugUnitPrice

Code

ImportedDrugUnitPrice

Data Type

NUMBER(19,10)

Mandatory

No

Comment

Cena za jednostke


Kolumna TreatmentSchemaID tabeli NFZContractServiceData

Definicja kolumny TreatmentSchemaID tabeli NFZContractServiceData

Name

TreatmentSchemaID

Code

TreatmentSchemaID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kod kursu chemioterapii


Kolumna DoseCalcMethodID tabeli NFZContractServiceData

Definicja kolumny DoseCalcMethodID tabeli NFZContractServiceData

Name

DoseCalcMethodID

Code

DoseCalcMethodID

Data Type

NUMBER(10)

Mandatory

No

Comment

Dawka okreslona wg.


Kolumna SplitContractCoding tabeli NFZContractServiceData

Definicja kolumny SplitContractCoding tabeli NFZContractServiceData

Name

SplitContractCoding

Code

SplitContractCoding

Data Type

NUMBER(5)

Mandatory

No

Comment

Gdy wartosc równa jest 1 to zakodowane swiadczenie przy badaniu ma byc wykazywane w odrebnym zestawie swiadczen


Kolumna SPOGlasgowEyesOpen tabeli NFZContractServiceData

Definicja kolumny SPOGlasgowEyesOpen tabeli NFZContractServiceData

Name

SPOGlasgowEyesOpen

Code

SPOGlasgowEyesOpen

Data Type

NUMBER(3)

Mandatory

No

Comment

otwieranie oczu wg skali Glasgow


Kolumna SPOGlasgowVerbalContact tabeli NFZContractServiceData

Definicja kolumny SPOGlasgowVerbalContact tabeli NFZContractServiceData

Name

SPOGlasgowVerbalContact

Code

SPOGlasgowVerbalContact

Data Type

NUMBER(3)

Mandatory

No

Comment

kontakt slowny wg skali Glasgow


Kolumna SPOGlasgowMovementResponse tabeli NFZContractServiceData

Definicja kolumny SPOGlasgowMovementResponse tabeli NFZContractServiceData

Name

SPOGlasgowMovementResponse

Code

SPOGlasgowMovementResponse

Data Type

NUMBER(3)

Mandatory

No

Comment

reakcje ruchowe wg skali Glasgow


Kolumna SPOGlasgowSum tabeli NFZContractServiceData

Definicja kolumny SPOGlasgowSum tabeli NFZContractServiceData

Name

SPOGlasgowSum

Code

SPOGlasgowSum

Data Type

NUMBER(5)

Mandatory

No

Comment

Suma 3 kolumn (SPOGlasgowEyesOpen, SPOGlasgowVerbalContact, SPOGlasgowMovementResponse), jest to w oddzielnej kolumnie poniewaz moze byc uzupelniona mimo braku uzupelnienia powyzszych kolumn.


Kolumna SPOBarthel tabeli NFZContractServiceData

Definicja kolumny SPOBarthel tabeli NFZContractServiceData

Name

SPOBarthel

Code

SPOBarthel

Data Type

NUMBER(3)

Mandatory

No

Comment

wynik badania pacjenta wg skali Barthel


Kolumna EAN tabeli NFZContractServiceData

Definicja kolumny EAN tabeli NFZContractServiceData

Name

EAN

Code

EAN

Data Type

VARCHAR2(16)

Mandatory

No

Comment

Materializuje wybrany kod przy pozycji rozliczeniowej zgodnie z wymaganiami komunikatu 1 fazy i rozporzadzen ministra zdrowia


Kolumna DrugPackagePrice tabeli NFZContractServiceData

Definicja kolumny DrugPackagePrice tabeli NFZContractServiceData

Name

DrugPackagePrice

Code

DrugPackagePrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Cena za opakowanie zakupionego leku


Kolumna DrugPackageUnitsCount tabeli NFZContractServiceData

Definicja kolumny DrugPackageUnitsCount tabeli NFZContractServiceData

Name

DrugPackageUnitsCount

Code

DrugPackageUnitsCount

Data Type

NUMBER(10,4)

Mandatory

No

Comment

Liczba rozliczeniowych jednostek miary zawartych w jednym opakowaniu zgodnie ze slownikiem produktów handlowych


Kolumna OutpatientMode tabeli NFZContractServiceData

Definicja kolumny OutpatientMode tabeli NFZContractServiceData

Name

OutpatientMode

Code

OutpatientMode

Data Type

NUMBER(5)

Mandatory

No

Comment

Informacja czy pobyt, na ktorym zostanie zakodowane dane swiadczenie ma byc rozliczony w trybie ambulatoryjnym - ustawia STER


Kolumna DrugTherapyStartDT tabeli NFZContractServiceData

Definicja kolumny DrugTherapyStartDT tabeli NFZContractServiceData

Name

DrugTherapyStartDT

Code

DrugTherapyStartDT

Data Type

DATE

Mandatory

No

Comment

data rozpoczecia terapii lekiem z dokladnoscia do dnia np. '2018-02-02' (bez godzin)


Kolumna DrugTherapyStopDT tabeli NFZContractServiceData

Definicja kolumny DrugTherapyStopDT tabeli NFZContractServiceData

Name

DrugTherapyStopDT

Code

DrugTherapyStopDT

Data Type

DATE

Mandatory

No

Comment

data zakonczenia terapii lekiem z dokladnoscia do dnia np. '2018-02-02' (bez godzin)


Kolumna PregnancyWeek tabeli NFZContractServiceData

Definicja kolumny PregnancyWeek tabeli NFZContractServiceData

Name

PregnancyWeek

Code

PregnancyWeek

Data Type

NUMBER(3)

Mandatory

No

Comment

tydzien ciazy


Lista kluczy tabeli NFZContractServiceData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli NFZContractServiceData

Definicja klucza Identifier_1 tabeli NFZContractServiceData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment